<?php
include "init.php";

$fran_count = $db->getOne("SELECT COUNT(fid) FROM $_SC[tablepre]franchisee WHERE is_delete=0 LIMIT 1");
$c1 = $db->getOne("SELECT COUNT(sid) FROM $_SC[tablepre]student WHERE is_delete=0 LIMIT 1");
$c2 = $db->getOne("SELECT COUNT(sid) FROM $_SC[tablepre]student WHERE status=1 AND is_delete=0 LIMIT 1");
$c3 = $db->getOne("SELECT COUNT(sid) FROM $_SC[tablepre]student WHERE status=2 AND is_delete=0 LIMIT 1");
$c4 = $db->getOne("SELECT COUNT(sid) FROM $_SC[tablepre]student WHERE status=3 AND is_delete=0 LIMIT 1");
$c5 = $db->getOne("SELECT COUNT(sid) FROM $_SC[tablepre]student WHERE status=4 AND is_delete=0 LIMIT 1");
$c6 = $db->getOne("SELECT COUNT(sid) FROM $_SC[tablepre]student WHERE status=5 AND is_delete=0 LIMIT 1");

$admin = $db->getRow("SELECT lastloginip, lastlogintime FROM $_SC[tablepre]admins WHERE userid='$_SESSION[adminid]' LIMIT 1");


include template('guide');
?>